<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.14"/>
<meta name="viewport" content="width=device-width, initial-scale=1"/>
<title>EasyQtSql: EasyQtSql/EasyQtSql_SqlFactory.h Source File</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="navtree.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="resize.js"></script>
<script type="text/javascript" src="navtreedata.js"></script>
<script type="text/javascript" src="navtree.js"></script>
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
  $(document).ready(initResizable);
/* @license-end */</script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/searchdata.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td id="projectalign" style="padding-left: 0.5em;">
   <div id="projectname">EasyQtSql
   </div>
   <div id="projectbrief">Easy SQL data access helper for QtSql</div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.14 -->
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
var searchBox = new SearchBox("searchBox", "search",false,'Search');
/* @license-end */
</script>
<script type="text/javascript" src="menudata.js"></script>
<script type="text/javascript" src="menu.js"></script>
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
$(function() {
  initMenu('',true,false,'search.php','Search');
  $(document).ready(function() { init_search(); });
});
/* @license-end */</script>
<div id="main-nav"></div>
</div><!-- top -->
<div id="side-nav" class="ui-resizable side-nav-resizable">
  <div id="nav-tree">
    <div id="nav-tree-contents">
      <div id="nav-sync" class="sync"></div>
    </div>
  </div>
  <div id="splitbar" style="-moz-user-select:none;" 
       class="ui-resizable-handle">
  </div>
</div>
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
$(document).ready(function(){initNavTree('_easy_qt_sql___sql_factory_8h_source.htm','');});
/* @license-end */
</script>
<div id="doc-content">
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
</div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<div class="header">
  <div class="headertitle">
<div class="title">EasyQtSql_SqlFactory.h</div>  </div>
</div><!--header-->
<div class="contents">
<a href="_easy_qt_sql___sql_factory_8h.htm">Go to the documentation of this file.</a><div class="fragment"><div class="line"><a name="l00001"></a><span class="lineno">    1</span>&#160;<span class="preprocessor">#ifndef EASYQTSQL_SQLFACTORY_H</span></div><div class="line"><a name="l00002"></a><span class="lineno">    2</span>&#160;<span class="preprocessor">#define EASYQTSQL_SQLFACTORY_H</span></div><div class="line"><a name="l00003"></a><span class="lineno">    3</span>&#160;</div><div class="line"><a name="l00004"></a><span class="lineno">    4</span>&#160;<span class="comment">/*</span></div><div class="line"><a name="l00005"></a><span class="lineno">    5</span>&#160;<span class="comment"> * The MIT License (MIT)</span></div><div class="line"><a name="l00006"></a><span class="lineno">    6</span>&#160;<span class="comment"> * Copyright 2018 Alexey Kramin</span></div><div class="line"><a name="l00007"></a><span class="lineno">    7</span>&#160;<span class="comment"> *</span></div><div class="line"><a name="l00008"></a><span class="lineno">    8</span>&#160;<span class="comment"> * Permission is hereby granted, free of charge, to any person obtaining</span></div><div class="line"><a name="l00009"></a><span class="lineno">    9</span>&#160;<span class="comment"> * a copy of this software and associated documentation files (the</span></div><div class="line"><a name="l00010"></a><span class="lineno">   10</span>&#160;<span class="comment"> * &quot;Software&quot;), to deal in the Software without restriction, including</span></div><div class="line"><a name="l00011"></a><span class="lineno">   11</span>&#160;<span class="comment"> * without limitation the rights to use, copy, modify, merge, publish,</span></div><div class="line"><a name="l00012"></a><span class="lineno">   12</span>&#160;<span class="comment"> * distribute, sublicense, and/or sell copies of the Software, and to</span></div><div class="line"><a name="l00013"></a><span class="lineno">   13</span>&#160;<span class="comment"> * permit persons to whom the Software is furnished to do so, subject to</span></div><div class="line"><a name="l00014"></a><span class="lineno">   14</span>&#160;<span class="comment"> * the following conditions:</span></div><div class="line"><a name="l00015"></a><span class="lineno">   15</span>&#160;<span class="comment"> *</span></div><div class="line"><a name="l00016"></a><span class="lineno">   16</span>&#160;<span class="comment"> * The above copyright notice and this permission notice shall be</span></div><div class="line"><a name="l00017"></a><span class="lineno">   17</span>&#160;<span class="comment"> * included in all copies or substantial portions of the Software.</span></div><div class="line"><a name="l00018"></a><span class="lineno">   18</span>&#160;<span class="comment"> *</span></div><div class="line"><a name="l00019"></a><span class="lineno">   19</span>&#160;<span class="comment"> * THE SOFTWARE IS PROVIDED &quot;AS IS&quot;, WITHOUT WARRANTY OF ANY KIND,</span></div><div class="line"><a name="l00020"></a><span class="lineno">   20</span>&#160;<span class="comment"> * EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF</span></div><div class="line"><a name="l00021"></a><span class="lineno">   21</span>&#160;<span class="comment"> * MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND</span></div><div class="line"><a name="l00022"></a><span class="lineno">   22</span>&#160;<span class="comment"> * NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE</span></div><div class="line"><a name="l00023"></a><span class="lineno">   23</span>&#160;<span class="comment"> * LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION</span></div><div class="line"><a name="l00024"></a><span class="lineno">   24</span>&#160;<span class="comment"> * OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION</span></div><div class="line"><a name="l00025"></a><span class="lineno">   25</span>&#160;<span class="comment"> * WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.</span></div><div class="line"><a name="l00026"></a><span class="lineno">   26</span>&#160;<span class="comment"> *</span></div><div class="line"><a name="l00027"></a><span class="lineno">   27</span>&#160;<span class="comment">*/</span></div><div class="line"><a name="l00028"></a><span class="lineno">   28</span>&#160;</div><div class="line"><a name="l00029"></a><span class="lineno">   29</span>&#160;<span class="preprocessor">#ifndef EASY_QT_SQL_MAIN</span></div><div class="line"><a name="l00030"></a><span class="lineno">   30</span>&#160;</div><div class="line"><a name="l00031"></a><span class="lineno">   31</span>&#160;<span class="preprocessor">#include &lt;QtSql&gt;</span></div><div class="line"><a name="l00032"></a><span class="lineno">   32</span>&#160;<span class="preprocessor">#include &lt;QException&gt;</span></div><div class="line"><a name="l00033"></a><span class="lineno">   33</span>&#160;</div><div class="line"><a name="l00034"></a><span class="lineno">   34</span>&#160;<span class="preprocessor">#endif</span></div><div class="line"><a name="l00035"></a><span class="lineno">   35</span>&#160;</div><div class="line"><a name="l00036"></a><span class="lineno"><a class="line" href="class_sql_factory.htm">   36</a></span>&#160;<span class="keyword">class </span><a class="code" href="class_sql_factory.htm">SqlFactory</a></div><div class="line"><a name="l00037"></a><span class="lineno">   37</span>&#160;{</div><div class="line"><a name="l00038"></a><span class="lineno">   38</span>&#160;<span class="keyword">public</span>:</div><div class="line"><a name="l00039"></a><span class="lineno">   39</span>&#160;</div><div class="line"><a name="l00040"></a><span class="lineno"><a class="line" href="class_sql_factory.htm#a99a9a94d77ee0cb3dbfbdce112764923">   40</a></span>&#160;   <span class="keyword">static</span> <a class="code" href="class_sql_factory.htm">SqlFactory</a> *<a class="code" href="class_sql_factory.htm#a99a9a94d77ee0cb3dbfbdce112764923">getInstance</a>()</div><div class="line"><a name="l00041"></a><span class="lineno">   41</span>&#160;   {</div><div class="line"><a name="l00042"></a><span class="lineno">   42</span>&#160;      <span class="keyword">static</span> <a class="code" href="class_sql_factory.htm">SqlFactory</a> instance;</div><div class="line"><a name="l00043"></a><span class="lineno">   43</span>&#160;      <span class="keywordflow">return</span> &amp;instance;</div><div class="line"><a name="l00044"></a><span class="lineno">   44</span>&#160;   }</div><div class="line"><a name="l00045"></a><span class="lineno">   45</span>&#160;</div><div class="line"><a name="l00046"></a><span class="lineno">   46</span>&#160;   <span class="keyword">class </span>ThreadDBPool;</div><div class="line"><a name="l00047"></a><span class="lineno">   47</span>&#160;</div><div class="line"><a name="l00048"></a><span class="lineno"><a class="line" href="struct_sql_factory_1_1_d_b_setting.htm">   48</a></span>&#160;   <span class="keyword">struct </span><a class="code" href="struct_sql_factory_1_1_d_b_setting.htm">DBSetting</a></div><div class="line"><a name="l00049"></a><span class="lineno">   49</span>&#160;   {</div><div class="line"><a name="l00050"></a><span class="lineno"><a class="line" href="struct_sql_factory_1_1_d_b_setting.htm#a6fd59254c088aa1b5ae3c314f2e74dc2">   50</a></span>&#160;      <span class="keyword">friend</span> <span class="keyword">class </span><a class="code" href="class_sql_factory_1_1_thread_d_b_pool.htm">ThreadDBPool</a>;</div><div class="line"><a name="l00051"></a><span class="lineno">   51</span>&#160;</div><div class="line"><a name="l00052"></a><span class="lineno"><a class="line" href="struct_sql_factory_1_1_d_b_setting.htm#a512b6207e0166201c62da1a764f7425c">   52</a></span>&#160;      <span class="keyword">typedef</span> QPair&lt;QString, QString&gt; <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a512b6207e0166201c62da1a764f7425c">KeywordValuePair</a>;</div><div class="line"><a name="l00053"></a><span class="lineno"><a class="line" href="struct_sql_factory_1_1_d_b_setting.htm#a1adc28c8e45cde95aa094c4172b79beb">   53</a></span>&#160;      <span class="keyword">typedef</span> QVector&lt;KeywordValuePair&gt; <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a1adc28c8e45cde95aa094c4172b79beb">ConnParameters</a>;</div><div class="line"><a name="l00054"></a><span class="lineno">   54</span>&#160;</div><div class="line"><a name="l00055"></a><span class="lineno"><a class="line" href="struct_sql_factory_1_1_d_b_setting.htm#a4cecaec15efae6fcef128aca09603513">   55</a></span>&#160;      <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a4cecaec15efae6fcef128aca09603513">DBSetting</a>()</div><div class="line"><a name="l00056"></a><span class="lineno">   56</span>&#160;      { }</div><div class="line"><a name="l00057"></a><span class="lineno">   57</span>&#160;</div><div class="line"><a name="l00058"></a><span class="lineno"><a class="line" href="struct_sql_factory_1_1_d_b_setting.htm#a770f3653954b15a1a6a940765c8ff44f">   58</a></span>&#160;      <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a770f3653954b15a1a6a940765c8ff44f">DBSetting</a>(<span class="keyword">const</span> QString &amp;type, <span class="keyword">const</span> QString &amp;connectionString)</div><div class="line"><a name="l00059"></a><span class="lineno">   59</span>&#160;         : type(type), dbName(connectionString)</div><div class="line"><a name="l00060"></a><span class="lineno">   60</span>&#160;      { }</div><div class="line"><a name="l00061"></a><span class="lineno">   61</span>&#160;</div><div class="line"><a name="l00062"></a><span class="lineno"><a class="line" href="struct_sql_factory_1_1_d_b_setting.htm#aca20852536794beb79fa735b219c29cb">   62</a></span>&#160;      <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#aca20852536794beb79fa735b219c29cb">DBSetting</a>(<span class="keyword">const</span> QString &amp;type, <span class="keyword">const</span> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a1adc28c8e45cde95aa094c4172b79beb">ConnParameters</a> &amp;params)</div><div class="line"><a name="l00063"></a><span class="lineno">   63</span>&#160;         : <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm">DBSetting</a>(type, createConnectionString(params))</div><div class="line"><a name="l00064"></a><span class="lineno">   64</span>&#160;      { }</div><div class="line"><a name="l00065"></a><span class="lineno">   65</span>&#160;</div><div class="line"><a name="l00066"></a><span class="lineno"><a class="line" href="struct_sql_factory_1_1_d_b_setting.htm#a9efb6d2e2221b3e4347171149eb684dd">   66</a></span>&#160;      <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a9efb6d2e2221b3e4347171149eb684dd">DBSetting</a>(<span class="keyword">const</span> QString &amp;type, <span class="keyword">const</span> QString &amp;host, <span class="keywordtype">int</span> port, <span class="keyword">const</span> QString &amp;username, <span class="keyword">const</span> QString &amp;password, <span class="keyword">const</span> QString &amp;dbname)</div><div class="line"><a name="l00067"></a><span class="lineno">   67</span>&#160;         : type(type), port(port), host(host), username(username), password(password), dbName(dbname)</div><div class="line"><a name="l00068"></a><span class="lineno">   68</span>&#160;      { }</div><div class="line"><a name="l00069"></a><span class="lineno">   69</span>&#160;</div><div class="line"><a name="l00070"></a><span class="lineno"><a class="line" href="struct_sql_factory_1_1_d_b_setting.htm#a67cc15ea0f8cb7e4d64e1e6a09933f65">   70</a></span>&#160;      <span class="keyword">static</span> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm">DBSetting</a> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a67cc15ea0f8cb7e4d64e1e6a09933f65">sqliteMemory</a>()</div><div class="line"><a name="l00071"></a><span class="lineno">   71</span>&#160;      {</div><div class="line"><a name="l00072"></a><span class="lineno">   72</span>&#160;         <span class="keywordflow">return</span> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a4cecaec15efae6fcef128aca09603513">DBSetting</a>(<span class="stringliteral">&quot;QSQLITE&quot;</span>, <span class="stringliteral">&quot;:memory:&quot;</span>);</div><div class="line"><a name="l00073"></a><span class="lineno">   73</span>&#160;      }</div><div class="line"><a name="l00074"></a><span class="lineno">   74</span>&#160;</div><div class="line"><a name="l00075"></a><span class="lineno"><a class="line" href="struct_sql_factory_1_1_d_b_setting.htm#abbdcd2f1826a79af0ae96a4841f339c6">   75</a></span>&#160;      <span class="keyword">static</span> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm">DBSetting</a> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#abbdcd2f1826a79af0ae96a4841f339c6">sqlite</a>(<span class="keyword">const</span> QString &amp;fileName)</div><div class="line"><a name="l00076"></a><span class="lineno">   76</span>&#160;      {</div><div class="line"><a name="l00077"></a><span class="lineno">   77</span>&#160;         <span class="keywordflow">return</span> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a4cecaec15efae6fcef128aca09603513">DBSetting</a>(<span class="stringliteral">&quot;QSQLITE&quot;</span>, fileName);</div><div class="line"><a name="l00078"></a><span class="lineno">   78</span>&#160;      }</div><div class="line"><a name="l00079"></a><span class="lineno">   79</span>&#160;</div><div class="line"><a name="l00080"></a><span class="lineno">   80</span>&#160;      <span class="comment">//https://docs.microsoft.com/ru-ru/dotnet/framework/data/adonet/connection-strings</span></div><div class="line"><a name="l00081"></a><span class="lineno">   81</span>&#160;      <span class="comment">//https://www.connectionstrings.com/sql-server/</span></div><div class="line"><a name="l00082"></a><span class="lineno">   82</span>&#160;</div><div class="line"><a name="l00083"></a><span class="lineno">   83</span>&#160;      <span class="comment">//MS SQL Server 2000 / 7.0 Standard Security</span></div><div class="line"><a name="l00084"></a><span class="lineno"><a class="line" href="struct_sql_factory_1_1_d_b_setting.htm#a5e5c83e7260175e8f538f072897976f5">   84</a></span>&#160;      <span class="keyword">static</span> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm">DBSetting</a> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a5e5c83e7260175e8f538f072897976f5">msSqlServerODBC</a>(<span class="keyword">const</span> QString &amp;server, <span class="keyword">const</span> QString &amp;database, <span class="keyword">const</span> QString &amp;userID, <span class="keyword">const</span> QString &amp;password, <span class="keyword">const</span> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a1adc28c8e45cde95aa094c4172b79beb">ConnParameters</a> &amp;extraParams = <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a1adc28c8e45cde95aa094c4172b79beb">ConnParameters</a>())</div><div class="line"><a name="l00085"></a><span class="lineno">   85</span>&#160;      {</div><div class="line"><a name="l00086"></a><span class="lineno">   86</span>&#160;         <span class="keywordflow">return</span> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a4cecaec15efae6fcef128aca09603513">DBSetting</a>(<span class="stringliteral">&quot;QODBC&quot;</span>,</div><div class="line"><a name="l00087"></a><span class="lineno">   87</span>&#160;                         {</div><div class="line"><a name="l00088"></a><span class="lineno">   88</span>&#160;                                 {<span class="stringliteral">&quot;Driver&quot;</span>, <span class="stringliteral">&quot;{SQL Server}&quot;</span>}</div><div class="line"><a name="l00089"></a><span class="lineno">   89</span>&#160;                             ,   {<span class="stringliteral">&quot;Server&quot;</span>, server}</div><div class="line"><a name="l00090"></a><span class="lineno">   90</span>&#160;                             ,   {<span class="stringliteral">&quot;Database&quot;</span>, database}</div><div class="line"><a name="l00091"></a><span class="lineno">   91</span>&#160;                             ,   {<span class="stringliteral">&quot;Uid&quot;</span>, userID}</div><div class="line"><a name="l00092"></a><span class="lineno">   92</span>&#160;                             ,   {<span class="stringliteral">&quot;Pwd&quot;</span>, password}</div><div class="line"><a name="l00093"></a><span class="lineno">   93</span>&#160;                         });</div><div class="line"><a name="l00094"></a><span class="lineno">   94</span>&#160;      }</div><div class="line"><a name="l00095"></a><span class="lineno">   95</span>&#160;</div><div class="line"><a name="l00096"></a><span class="lineno">   96</span>&#160;      <span class="comment">//MS SQL Server 2000 / 7.0 Trusted connection</span></div><div class="line"><a name="l00097"></a><span class="lineno"><a class="line" href="struct_sql_factory_1_1_d_b_setting.htm#a0f6188ce9c0615f08c3d2421363e6ef8">   97</a></span>&#160;      <span class="keyword">static</span> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm">DBSetting</a> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a0f6188ce9c0615f08c3d2421363e6ef8">msSqlServerODBC</a>(<span class="keyword">const</span> QString &amp;server, <span class="keyword">const</span> QString &amp;database, <span class="keyword">const</span> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a1adc28c8e45cde95aa094c4172b79beb">ConnParameters</a> &amp;extraParams = <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a1adc28c8e45cde95aa094c4172b79beb">ConnParameters</a>())</div><div class="line"><a name="l00098"></a><span class="lineno">   98</span>&#160;      {                  </div><div class="line"><a name="l00099"></a><span class="lineno">   99</span>&#160;         <span class="keywordflow">return</span> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a4cecaec15efae6fcef128aca09603513">DBSetting</a>(<span class="stringliteral">&quot;QODBC&quot;</span>,</div><div class="line"><a name="l00100"></a><span class="lineno">  100</span>&#160;                         {</div><div class="line"><a name="l00101"></a><span class="lineno">  101</span>&#160;                                 {<span class="stringliteral">&quot;Driver&quot;</span>, <span class="stringliteral">&quot;{SQL Server}&quot;</span>}</div><div class="line"><a name="l00102"></a><span class="lineno">  102</span>&#160;                             ,   {<span class="stringliteral">&quot;Server&quot;</span>, server}</div><div class="line"><a name="l00103"></a><span class="lineno">  103</span>&#160;                             ,   {<span class="stringliteral">&quot;Database&quot;</span>, database}</div><div class="line"><a name="l00104"></a><span class="lineno">  104</span>&#160;                             ,   {<span class="stringliteral">&quot;Trusted_Connection&quot;</span>, <span class="stringliteral">&quot;Yes&quot;</span>}</div><div class="line"><a name="l00105"></a><span class="lineno">  105</span>&#160;                         });</div><div class="line"><a name="l00106"></a><span class="lineno">  106</span>&#160;      }</div><div class="line"><a name="l00107"></a><span class="lineno">  107</span>&#160;</div><div class="line"><a name="l00108"></a><span class="lineno">  108</span>&#160;      <span class="comment">//MS SQL Server 2000 / 2005 / 7.0 SQL Native Client 9.0 Standard Security</span></div><div class="line"><a name="l00109"></a><span class="lineno"><a class="line" href="struct_sql_factory_1_1_d_b_setting.htm#a1f4dcce1487c3354ab53e648c02c7f4e">  109</a></span>&#160;      <span class="keyword">static</span> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm">DBSetting</a> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a1f4dcce1487c3354ab53e648c02c7f4e">msSqlServerNativeClient90ODBC</a>(<span class="keyword">const</span> QString &amp;server, <span class="keyword">const</span> QString &amp;database, <span class="keyword">const</span> QString &amp;userID, <span class="keyword">const</span> QString &amp;password, <span class="keyword">const</span> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a1adc28c8e45cde95aa094c4172b79beb">ConnParameters</a> &amp;extraParams = <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a1adc28c8e45cde95aa094c4172b79beb">ConnParameters</a>())</div><div class="line"><a name="l00110"></a><span class="lineno">  110</span>&#160;      {</div><div class="line"><a name="l00111"></a><span class="lineno">  111</span>&#160;         <span class="keywordflow">return</span> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a4cecaec15efae6fcef128aca09603513">DBSetting</a>(<span class="stringliteral">&quot;QODBC&quot;</span>,</div><div class="line"><a name="l00112"></a><span class="lineno">  112</span>&#160;                         {</div><div class="line"><a name="l00113"></a><span class="lineno">  113</span>&#160;                                 {<span class="stringliteral">&quot;Driver&quot;</span>, <span class="stringliteral">&quot;{SQL Native Client}&quot;</span>}</div><div class="line"><a name="l00114"></a><span class="lineno">  114</span>&#160;                             ,   {<span class="stringliteral">&quot;Server&quot;</span>, server}</div><div class="line"><a name="l00115"></a><span class="lineno">  115</span>&#160;                             ,   {<span class="stringliteral">&quot;Database&quot;</span>, database}</div><div class="line"><a name="l00116"></a><span class="lineno">  116</span>&#160;                             ,   {<span class="stringliteral">&quot;Uid&quot;</span>, userID}</div><div class="line"><a name="l00117"></a><span class="lineno">  117</span>&#160;                             ,   {<span class="stringliteral">&quot;Pwd&quot;</span>, password}</div><div class="line"><a name="l00118"></a><span class="lineno">  118</span>&#160;                         });</div><div class="line"><a name="l00119"></a><span class="lineno">  119</span>&#160;      }</div><div class="line"><a name="l00120"></a><span class="lineno">  120</span>&#160;</div><div class="line"><a name="l00121"></a><span class="lineno">  121</span>&#160;      <span class="comment">//MS SQL Server 2000 / 2005 / 7.0 SQL Native Client 9.0 Trusted connection</span></div><div class="line"><a name="l00122"></a><span class="lineno"><a class="line" href="struct_sql_factory_1_1_d_b_setting.htm#a1e8c5e64de22656dab6a737827d55bb7">  122</a></span>&#160;      <span class="keyword">static</span> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm">DBSetting</a> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a1e8c5e64de22656dab6a737827d55bb7">msSqlServerNativeClient90ODBC</a>(<span class="keyword">const</span> QString &amp;server, <span class="keyword">const</span> QString &amp;database, <span class="keyword">const</span> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a1adc28c8e45cde95aa094c4172b79beb">ConnParameters</a> &amp;extraParams = <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a1adc28c8e45cde95aa094c4172b79beb">ConnParameters</a>())</div><div class="line"><a name="l00123"></a><span class="lineno">  123</span>&#160;      {</div><div class="line"><a name="l00124"></a><span class="lineno">  124</span>&#160;         <span class="keywordflow">return</span> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a4cecaec15efae6fcef128aca09603513">DBSetting</a>(<span class="stringliteral">&quot;QODBC&quot;</span>,</div><div class="line"><a name="l00125"></a><span class="lineno">  125</span>&#160;                         {</div><div class="line"><a name="l00126"></a><span class="lineno">  126</span>&#160;                                 {<span class="stringliteral">&quot;Driver&quot;</span>, <span class="stringliteral">&quot;{SQL Native Client}&quot;</span>}</div><div class="line"><a name="l00127"></a><span class="lineno">  127</span>&#160;                             ,   {<span class="stringliteral">&quot;Server&quot;</span>, server}</div><div class="line"><a name="l00128"></a><span class="lineno">  128</span>&#160;                             ,   {<span class="stringliteral">&quot;Database&quot;</span>, database}</div><div class="line"><a name="l00129"></a><span class="lineno">  129</span>&#160;                             ,   {<span class="stringliteral">&quot;Trusted_Connection&quot;</span>, <span class="stringliteral">&quot;Yes&quot;</span>}</div><div class="line"><a name="l00130"></a><span class="lineno">  130</span>&#160;                         });</div><div class="line"><a name="l00131"></a><span class="lineno">  131</span>&#160;      }</div><div class="line"><a name="l00132"></a><span class="lineno">  132</span>&#160;</div><div class="line"><a name="l00133"></a><span class="lineno">  133</span>&#160;</div><div class="line"><a name="l00134"></a><span class="lineno">  134</span>&#160;</div><div class="line"><a name="l00135"></a><span class="lineno"><a class="line" href="struct_sql_factory_1_1_d_b_setting.htm#a7a079094d80a3ad77a621f08cf0c942b">  135</a></span>&#160;      QString <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a7a079094d80a3ad77a621f08cf0c942b">getType</a>()<span class="keyword"> const</span></div><div class="line"><a name="l00136"></a><span class="lineno">  136</span>&#160;<span class="keyword">      </span>{</div><div class="line"><a name="l00137"></a><span class="lineno">  137</span>&#160;         <span class="keywordflow">return</span> type.isEmpty() ? <span class="stringliteral">&quot;QODBC&quot;</span> : type;</div><div class="line"><a name="l00138"></a><span class="lineno">  138</span>&#160;      }</div><div class="line"><a name="l00139"></a><span class="lineno">  139</span>&#160;</div><div class="line"><a name="l00140"></a><span class="lineno">  140</span>&#160;   <span class="keyword">private</span>:</div><div class="line"><a name="l00141"></a><span class="lineno">  141</span>&#160;      QString  type;</div><div class="line"><a name="l00142"></a><span class="lineno">  142</span>&#160;      QVariant port;</div><div class="line"><a name="l00143"></a><span class="lineno">  143</span>&#160;      QString  host;</div><div class="line"><a name="l00144"></a><span class="lineno">  144</span>&#160;      QString  username;</div><div class="line"><a name="l00145"></a><span class="lineno">  145</span>&#160;      QString  password;</div><div class="line"><a name="l00146"></a><span class="lineno">  146</span>&#160;      QString  dbName;</div><div class="line"><a name="l00147"></a><span class="lineno">  147</span>&#160;</div><div class="line"><a name="l00148"></a><span class="lineno">  148</span>&#160;      <span class="keyword">static</span> QString createConnectionString(<span class="keyword">const</span> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a1adc28c8e45cde95aa094c4172b79beb">ConnParameters</a> &amp;params)</div><div class="line"><a name="l00149"></a><span class="lineno">  149</span>&#160;      {</div><div class="line"><a name="l00150"></a><span class="lineno">  150</span>&#160;         QString res;</div><div class="line"><a name="l00151"></a><span class="lineno">  151</span>&#160;         res.reserve(256);</div><div class="line"><a name="l00152"></a><span class="lineno">  152</span>&#160;</div><div class="line"><a name="l00153"></a><span class="lineno">  153</span>&#160;         <span class="keywordflow">for</span> (<span class="keyword">const</span> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a512b6207e0166201c62da1a764f7425c">KeywordValuePair</a> &amp;pair: params)</div><div class="line"><a name="l00154"></a><span class="lineno">  154</span>&#160;         {</div><div class="line"><a name="l00155"></a><span class="lineno">  155</span>&#160;            <span class="keyword">const</span> QString &amp;key   = pair.first;</div><div class="line"><a name="l00156"></a><span class="lineno">  156</span>&#160;            <span class="keyword">const</span> QString &amp;value = pair.second;</div><div class="line"><a name="l00157"></a><span class="lineno">  157</span>&#160;</div><div class="line"><a name="l00158"></a><span class="lineno">  158</span>&#160;            res.append(key).append(<span class="charliteral">&#39;=&#39;</span>);</div><div class="line"><a name="l00159"></a><span class="lineno">  159</span>&#160;</div><div class="line"><a name="l00160"></a><span class="lineno">  160</span>&#160;            <span class="keyword">auto</span> containsControlChar = [](<span class="keyword">const</span> QString &amp;value) -&gt; <span class="keywordtype">bool</span></div><div class="line"><a name="l00161"></a><span class="lineno">  161</span>&#160;            {</div><div class="line"><a name="l00162"></a><span class="lineno">  162</span>&#160;               <span class="keywordflow">for</span> (<span class="keywordtype">int</span> i = 0; i &lt; value.size(); ++i)</div><div class="line"><a name="l00163"></a><span class="lineno">  163</span>&#160;               {</div><div class="line"><a name="l00164"></a><span class="lineno">  164</span>&#160;                  <span class="keywordflow">if</span> (value[i].category() == QChar::Other_Control)</div><div class="line"><a name="l00165"></a><span class="lineno">  165</span>&#160;                     <span class="keywordflow">return</span> <span class="keyword">true</span>;</div><div class="line"><a name="l00166"></a><span class="lineno">  166</span>&#160;               }</div><div class="line"><a name="l00167"></a><span class="lineno">  167</span>&#160;</div><div class="line"><a name="l00168"></a><span class="lineno">  168</span>&#160;               <span class="keywordflow">return</span> <span class="keyword">false</span>;</div><div class="line"><a name="l00169"></a><span class="lineno">  169</span>&#160;            };</div><div class="line"><a name="l00170"></a><span class="lineno">  170</span>&#160;</div><div class="line"><a name="l00171"></a><span class="lineno">  171</span>&#160;            <span class="keywordflow">if</span> ( value.startsWith(QChar::Space) || value.endsWith(QChar::Space) || value.contains(<span class="charliteral">&#39;;&#39;</span>) || containsControlChar(value) )</div><div class="line"><a name="l00172"></a><span class="lineno">  172</span>&#160;            {</div><div class="line"><a name="l00173"></a><span class="lineno">  173</span>&#160;               <span class="keyword">const</span> <span class="keywordtype">bool</span> containsSingleQuotes = value.contains(QChar(<span class="charliteral">&#39;\&#39;&#39;</span>));</div><div class="line"><a name="l00174"></a><span class="lineno">  174</span>&#160;               <span class="keyword">const</span> <span class="keywordtype">bool</span> containsDoubleQuotes = value.contains(QChar(<span class="charliteral">&#39;\&quot;&#39;</span>));</div><div class="line"><a name="l00175"></a><span class="lineno">  175</span>&#160;</div><div class="line"><a name="l00176"></a><span class="lineno">  176</span>&#160;               <span class="keywordflow">if</span> (containsSingleQuotes &amp;&amp; containsDoubleQuotes)</div><div class="line"><a name="l00177"></a><span class="lineno">  177</span>&#160;               {</div><div class="line"><a name="l00178"></a><span class="lineno">  178</span>&#160;                  res.append(<span class="charliteral">&#39;;&#39;</span>);</div><div class="line"><a name="l00179"></a><span class="lineno">  179</span>&#160;                  <span class="keywordflow">continue</span>;</div><div class="line"><a name="l00180"></a><span class="lineno">  180</span>&#160;               }</div><div class="line"><a name="l00181"></a><span class="lineno">  181</span>&#160;               <span class="keywordflow">else</span> <span class="keywordflow">if</span> (containsSingleQuotes)</div><div class="line"><a name="l00182"></a><span class="lineno">  182</span>&#160;               {</div><div class="line"><a name="l00183"></a><span class="lineno">  183</span>&#160;                  res.append(<span class="charliteral">&#39;\&quot;&#39;</span>).append(value).append(<span class="charliteral">&#39;\&quot;&#39;</span>);</div><div class="line"><a name="l00184"></a><span class="lineno">  184</span>&#160;               }</div><div class="line"><a name="l00185"></a><span class="lineno">  185</span>&#160;               <span class="keywordflow">else</span> <span class="keywordflow">if</span> (containsDoubleQuotes)</div><div class="line"><a name="l00186"></a><span class="lineno">  186</span>&#160;               {</div><div class="line"><a name="l00187"></a><span class="lineno">  187</span>&#160;                  res.append(<span class="charliteral">&#39;\&#39;&#39;</span>).append(value).append(<span class="charliteral">&#39;\&#39;&#39;</span>);</div><div class="line"><a name="l00188"></a><span class="lineno">  188</span>&#160;               }</div><div class="line"><a name="l00189"></a><span class="lineno">  189</span>&#160;            }</div><div class="line"><a name="l00190"></a><span class="lineno">  190</span>&#160;            <span class="keywordflow">else</span></div><div class="line"><a name="l00191"></a><span class="lineno">  191</span>&#160;            {</div><div class="line"><a name="l00192"></a><span class="lineno">  192</span>&#160;               res.append(value);</div><div class="line"><a name="l00193"></a><span class="lineno">  193</span>&#160;            }</div><div class="line"><a name="l00194"></a><span class="lineno">  194</span>&#160;</div><div class="line"><a name="l00195"></a><span class="lineno">  195</span>&#160;            res.append(<span class="charliteral">&#39;;&#39;</span>);</div><div class="line"><a name="l00196"></a><span class="lineno">  196</span>&#160;         }</div><div class="line"><a name="l00197"></a><span class="lineno">  197</span>&#160;</div><div class="line"><a name="l00198"></a><span class="lineno">  198</span>&#160;         <span class="keywordflow">return</span> res;</div><div class="line"><a name="l00199"></a><span class="lineno">  199</span>&#160;      }</div><div class="line"><a name="l00200"></a><span class="lineno">  200</span>&#160;   };</div><div class="line"><a name="l00201"></a><span class="lineno">  201</span>&#160;</div><div class="line"><a name="l00202"></a><span class="lineno"><a class="line" href="class_sql_factory_1_1_thread_d_b_pool.htm">  202</a></span>&#160;   <span class="keyword">class </span><a class="code" href="class_sql_factory_1_1_thread_d_b_pool.htm">ThreadDBPool</a></div><div class="line"><a name="l00203"></a><span class="lineno">  203</span>&#160;   {</div><div class="line"><a name="l00204"></a><span class="lineno">  204</span>&#160;   <span class="keyword">public</span>:</div><div class="line"><a name="l00205"></a><span class="lineno">  205</span>&#160;</div><div class="line"><a name="l00206"></a><span class="lineno"><a class="line" href="class_sql_factory_1_1_thread_d_b_pool.htm#afec68318f044937be7ef65dbb695fb7a">  206</a></span>&#160;      <a class="code" href="class_sql_factory_1_1_thread_d_b_pool.htm#afec68318f044937be7ef65dbb695fb7a">~ThreadDBPool</a>()</div><div class="line"><a name="l00207"></a><span class="lineno">  207</span>&#160;      {</div><div class="line"><a name="l00208"></a><span class="lineno">  208</span>&#160;         <span class="keywordflow">for</span> (<span class="keyword">const</span> QString &amp;uniqueConnName : m_connNameMap.values())</div><div class="line"><a name="l00209"></a><span class="lineno">  209</span>&#160;         {</div><div class="line"><a name="l00210"></a><span class="lineno">  210</span>&#160;            {</div><div class="line"><a name="l00211"></a><span class="lineno">  211</span>&#160;               QSqlDatabase db = QSqlDatabase::database(uniqueConnName);</div><div class="line"><a name="l00212"></a><span class="lineno">  212</span>&#160;               <span class="keywordflow">if</span> (db.isOpen())</div><div class="line"><a name="l00213"></a><span class="lineno">  213</span>&#160;               {</div><div class="line"><a name="l00214"></a><span class="lineno">  214</span>&#160;                  db.close();</div><div class="line"><a name="l00215"></a><span class="lineno">  215</span>&#160;               }</div><div class="line"><a name="l00216"></a><span class="lineno">  216</span>&#160;            }</div><div class="line"><a name="l00217"></a><span class="lineno">  217</span>&#160;</div><div class="line"><a name="l00218"></a><span class="lineno">  218</span>&#160;            QSqlDatabase::removeDatabase(uniqueConnName);</div><div class="line"><a name="l00219"></a><span class="lineno">  219</span>&#160;         }</div><div class="line"><a name="l00220"></a><span class="lineno">  220</span>&#160;      }</div><div class="line"><a name="l00221"></a><span class="lineno">  221</span>&#160;</div><div class="line"><a name="l00222"></a><span class="lineno"><a class="line" href="class_sql_factory_1_1_thread_d_b_pool.htm#acaa0328fa9e8fd5975cbe8a6515ebad8">  222</a></span>&#160;      <span class="keywordtype">void</span> <a class="code" href="class_sql_factory_1_1_thread_d_b_pool.htm#acaa0328fa9e8fd5975cbe8a6515ebad8">addConnection</a>(<span class="keyword">const</span> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm">DBSetting</a> &amp;settings, <span class="keyword">const</span> QString &amp;connectionName)</div><div class="line"><a name="l00223"></a><span class="lineno">  223</span>&#160;      {</div><div class="line"><a name="l00224"></a><span class="lineno">  224</span>&#160;         <span class="keyword">const</span> QString uniqueConnectionName = connectionName + QUuid::createUuid().toString();</div><div class="line"><a name="l00225"></a><span class="lineno">  225</span>&#160;</div><div class="line"><a name="l00226"></a><span class="lineno">  226</span>&#160;         m_connNameMap.insert(connectionName, uniqueConnectionName);</div><div class="line"><a name="l00227"></a><span class="lineno">  227</span>&#160;</div><div class="line"><a name="l00228"></a><span class="lineno">  228</span>&#160;         QSqlDatabase db = QSqlDatabase::addDatabase(settings.<a class="code" href="struct_sql_factory_1_1_d_b_setting.htm#a7a079094d80a3ad77a621f08cf0c942b">getType</a>(), uniqueConnectionName);</div><div class="line"><a name="l00229"></a><span class="lineno">  229</span>&#160;</div><div class="line"><a name="l00230"></a><span class="lineno">  230</span>&#160;         db.setDatabaseName(settings.dbName);</div><div class="line"><a name="l00231"></a><span class="lineno">  231</span>&#160;         db.setHostName(settings.host);</div><div class="line"><a name="l00232"></a><span class="lineno">  232</span>&#160;         db.setUserName(settings.username);</div><div class="line"><a name="l00233"></a><span class="lineno">  233</span>&#160;         db.setPassword(settings.password);</div><div class="line"><a name="l00234"></a><span class="lineno">  234</span>&#160;</div><div class="line"><a name="l00235"></a><span class="lineno">  235</span>&#160;         <span class="keywordflow">if</span> (settings.port.isValid())</div><div class="line"><a name="l00236"></a><span class="lineno">  236</span>&#160;         {</div><div class="line"><a name="l00237"></a><span class="lineno">  237</span>&#160;            db.setPort(settings.port.toInt());</div><div class="line"><a name="l00238"></a><span class="lineno">  238</span>&#160;         }</div><div class="line"><a name="l00239"></a><span class="lineno">  239</span>&#160;      }</div><div class="line"><a name="l00240"></a><span class="lineno">  240</span>&#160;</div><div class="line"><a name="l00241"></a><span class="lineno"><a class="line" href="class_sql_factory_1_1_thread_d_b_pool.htm#a57d1dfa755fdfdf49c653acd596fabf9">  241</a></span>&#160;      <span class="keywordtype">bool</span> <a class="code" href="class_sql_factory_1_1_thread_d_b_pool.htm#a57d1dfa755fdfdf49c653acd596fabf9">connectionExists</a>(<span class="keyword">const</span> QString &amp;connectionName)<span class="keyword"> const</span></div><div class="line"><a name="l00242"></a><span class="lineno">  242</span>&#160;<span class="keyword">      </span>{</div><div class="line"><a name="l00243"></a><span class="lineno">  243</span>&#160;         <span class="keywordflow">return</span> m_connNameMap.contains(connectionName);</div><div class="line"><a name="l00244"></a><span class="lineno">  244</span>&#160;      }</div><div class="line"><a name="l00245"></a><span class="lineno">  245</span>&#160;</div><div class="line"><a name="l00246"></a><span class="lineno"><a class="line" href="class_sql_factory_1_1_thread_d_b_pool.htm#ae26407e9a40ec0077c71dcad8836cff7">  246</a></span>&#160;      QSqlDatabase <a class="code" href="class_sql_factory_1_1_thread_d_b_pool.htm#ae26407e9a40ec0077c71dcad8836cff7">getDatabase</a>(<span class="keyword">const</span> QString &amp;connectionName)<span class="keyword"> const</span></div><div class="line"><a name="l00247"></a><span class="lineno">  247</span>&#160;<span class="keyword">      </span>{</div><div class="line"><a name="l00248"></a><span class="lineno">  248</span>&#160;         <span class="keyword">const</span> QString &amp;uniqueConnectionName = m_connNameMap.value(connectionName);</div><div class="line"><a name="l00249"></a><span class="lineno">  249</span>&#160;</div><div class="line"><a name="l00250"></a><span class="lineno">  250</span>&#160;         QSqlDatabase db = QSqlDatabase::database(uniqueConnectionName);</div><div class="line"><a name="l00251"></a><span class="lineno">  251</span>&#160;</div><div class="line"><a name="l00252"></a><span class="lineno">  252</span>&#160;         <span class="keywordflow">if</span> (!db.isOpen())</div><div class="line"><a name="l00253"></a><span class="lineno">  253</span>&#160;         {</div><div class="line"><a name="l00254"></a><span class="lineno">  254</span>&#160;            <span class="keywordflow">if</span> (!db.open())</div><div class="line"><a name="l00255"></a><span class="lineno">  255</span>&#160;            {</div><div class="line"><a name="l00256"></a><span class="lineno">  256</span>&#160;               qCritical() &lt;&lt; db.lastError().text();</div><div class="line"><a name="l00257"></a><span class="lineno">  257</span>&#160;            }</div><div class="line"><a name="l00258"></a><span class="lineno">  258</span>&#160;         }</div><div class="line"><a name="l00259"></a><span class="lineno">  259</span>&#160;</div><div class="line"><a name="l00260"></a><span class="lineno">  260</span>&#160;         <span class="keywordflow">return</span> db;</div><div class="line"><a name="l00261"></a><span class="lineno">  261</span>&#160;      }</div><div class="line"><a name="l00262"></a><span class="lineno">  262</span>&#160;</div><div class="line"><a name="l00263"></a><span class="lineno">  263</span>&#160;   <span class="keyword">private</span>:</div><div class="line"><a name="l00264"></a><span class="lineno">  264</span>&#160;      QMap&lt;QString, QString&gt; m_connNameMap;</div><div class="line"><a name="l00265"></a><span class="lineno">  265</span>&#160;   };</div><div class="line"><a name="l00266"></a><span class="lineno">  266</span>&#160;</div><div class="line"><a name="l00267"></a><span class="lineno"><a class="line" href="class_sql_factory.htm#aba9fae52920d49b9c11e12f243690bfa">  267</a></span>&#160;   <a class="code" href="class_sql_factory.htm">SqlFactory</a> *<a class="code" href="class_sql_factory.htm#aba9fae52920d49b9c11e12f243690bfa">config</a>(<span class="keyword">const</span> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm">DBSetting</a> &amp;settings, <span class="keyword">const</span> QString &amp;connectionName = QSqlDatabase::defaultConnection)</div><div class="line"><a name="l00268"></a><span class="lineno">  268</span>&#160;   {</div><div class="line"><a name="l00269"></a><span class="lineno">  269</span>&#160;      QMutexLocker locker(&amp;mutex);</div><div class="line"><a name="l00270"></a><span class="lineno">  270</span>&#160;</div><div class="line"><a name="l00271"></a><span class="lineno">  271</span>&#160;      m_settings.insert(connectionName, settings);</div><div class="line"><a name="l00272"></a><span class="lineno">  272</span>&#160;</div><div class="line"><a name="l00273"></a><span class="lineno">  273</span>&#160;      <span class="keywordflow">return</span> <span class="keyword">this</span>;</div><div class="line"><a name="l00274"></a><span class="lineno">  274</span>&#160;   }</div><div class="line"><a name="l00275"></a><span class="lineno">  275</span>&#160;</div><div class="line"><a name="l00276"></a><span class="lineno"><a class="line" href="class_sql_factory.htm#a64dc81e8275c89d1b2b7c7fb383ab475">  276</a></span>&#160;   <a class="code" href="class_sql_factory.htm">SqlFactory</a> *<a class="code" href="class_sql_factory.htm#a64dc81e8275c89d1b2b7c7fb383ab475">clone</a>(<span class="keyword">const</span> QString &amp;newConnectionName, <span class="keyword">const</span> QString &amp;connectionName)</div><div class="line"><a name="l00277"></a><span class="lineno">  277</span>&#160;   {</div><div class="line"><a name="l00278"></a><span class="lineno">  278</span>&#160;      QMutexLocker locker(&amp;mutex);</div><div class="line"><a name="l00279"></a><span class="lineno">  279</span>&#160;</div><div class="line"><a name="l00280"></a><span class="lineno">  280</span>&#160;      <span class="keywordflow">if</span> (newConnectionName == connectionName)</div><div class="line"><a name="l00281"></a><span class="lineno">  281</span>&#160;         <span class="keywordflow">return</span> <span class="keyword">this</span>;</div><div class="line"><a name="l00282"></a><span class="lineno">  282</span>&#160;</div><div class="line"><a name="l00283"></a><span class="lineno">  283</span>&#160;      <span class="keywordflow">if</span> (m_settings.contains(connectionName))</div><div class="line"><a name="l00284"></a><span class="lineno">  284</span>&#160;      {</div><div class="line"><a name="l00285"></a><span class="lineno">  285</span>&#160;         <span class="keyword">const</span> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm">DBSetting</a> &amp;setting = m_settings[connectionName];</div><div class="line"><a name="l00286"></a><span class="lineno">  286</span>&#160;         m_settings.insert(newConnectionName, setting);</div><div class="line"><a name="l00287"></a><span class="lineno">  287</span>&#160;      }</div><div class="line"><a name="l00288"></a><span class="lineno">  288</span>&#160;</div><div class="line"><a name="l00289"></a><span class="lineno">  289</span>&#160;      <span class="keywordflow">return</span> <span class="keyword">this</span>;</div><div class="line"><a name="l00290"></a><span class="lineno">  290</span>&#160;   }</div><div class="line"><a name="l00291"></a><span class="lineno">  291</span>&#160;</div><div class="line"><a name="l00292"></a><span class="lineno"><a class="line" href="class_sql_factory.htm#a18d96e47f512a3bc4ba8cb07336acb54">  292</a></span>&#160;   QSqlDatabase <a class="code" href="class_sql_factory.htm#a18d96e47f512a3bc4ba8cb07336acb54">getDatabase</a>(<span class="keyword">const</span> QString &amp;connectionName = QSqlDatabase::defaultConnection)</div><div class="line"><a name="l00293"></a><span class="lineno">  293</span>&#160;   {</div><div class="line"><a name="l00294"></a><span class="lineno">  294</span>&#160;      QMutexLocker locker(&amp;mutex);</div><div class="line"><a name="l00295"></a><span class="lineno">  295</span>&#160;</div><div class="line"><a name="l00296"></a><span class="lineno">  296</span>&#160;      <span class="keywordflow">if</span> (m_settings.contains(connectionName))</div><div class="line"><a name="l00297"></a><span class="lineno">  297</span>&#160;      {</div><div class="line"><a name="l00298"></a><span class="lineno">  298</span>&#160;         <a class="code" href="class_sql_factory_1_1_thread_d_b_pool.htm">ThreadDBPool</a> *threadDbPool = <span class="keyword">nullptr</span>;</div><div class="line"><a name="l00299"></a><span class="lineno">  299</span>&#160;</div><div class="line"><a name="l00300"></a><span class="lineno">  300</span>&#160;         <span class="keywordflow">if</span> (!m_dbPool.hasLocalData())</div><div class="line"><a name="l00301"></a><span class="lineno">  301</span>&#160;         {</div><div class="line"><a name="l00302"></a><span class="lineno">  302</span>&#160;            threadDbPool = <span class="keyword">new</span> <a class="code" href="class_sql_factory_1_1_thread_d_b_pool.htm">ThreadDBPool</a>(); <span class="comment">//new pool for current thread</span></div><div class="line"><a name="l00303"></a><span class="lineno">  303</span>&#160;</div><div class="line"><a name="l00304"></a><span class="lineno">  304</span>&#160;            m_dbPool.setLocalData(threadDbPool);</div><div class="line"><a name="l00305"></a><span class="lineno">  305</span>&#160;         }</div><div class="line"><a name="l00306"></a><span class="lineno">  306</span>&#160;         <span class="keywordflow">else</span></div><div class="line"><a name="l00307"></a><span class="lineno">  307</span>&#160;         {</div><div class="line"><a name="l00308"></a><span class="lineno">  308</span>&#160;            threadDbPool = m_dbPool.localData();</div><div class="line"><a name="l00309"></a><span class="lineno">  309</span>&#160;         }</div><div class="line"><a name="l00310"></a><span class="lineno">  310</span>&#160;</div><div class="line"><a name="l00311"></a><span class="lineno">  311</span>&#160;         <span class="keywordflow">if</span> (threadDbPool)</div><div class="line"><a name="l00312"></a><span class="lineno">  312</span>&#160;         {</div><div class="line"><a name="l00313"></a><span class="lineno">  313</span>&#160;            <span class="keywordflow">if</span> (!threadDbPool-&gt;<a class="code" href="class_sql_factory_1_1_thread_d_b_pool.htm#a57d1dfa755fdfdf49c653acd596fabf9">connectionExists</a>(connectionName)) <span class="comment">//if no connection created for current thread</span></div><div class="line"><a name="l00314"></a><span class="lineno">  314</span>&#160;            {</div><div class="line"><a name="l00315"></a><span class="lineno">  315</span>&#160;               <span class="keyword">const</span> <a class="code" href="struct_sql_factory_1_1_d_b_setting.htm">DBSetting</a> &amp;settings = m_settings[connectionName];</div><div class="line"><a name="l00316"></a><span class="lineno">  316</span>&#160;</div><div class="line"><a name="l00317"></a><span class="lineno">  317</span>&#160;               threadDbPool-&gt;<a class="code" href="class_sql_factory_1_1_thread_d_b_pool.htm#acaa0328fa9e8fd5975cbe8a6515ebad8">addConnection</a>(settings, connectionName); <span class="comment">//create new connection with specified settings for current thread</span></div><div class="line"><a name="l00318"></a><span class="lineno">  318</span>&#160;            }</div><div class="line"><a name="l00319"></a><span class="lineno">  319</span>&#160;</div><div class="line"><a name="l00320"></a><span class="lineno">  320</span>&#160;            <span class="keywordflow">return</span> threadDbPool-&gt;<a class="code" href="class_sql_factory_1_1_thread_d_b_pool.htm#ae26407e9a40ec0077c71dcad8836cff7">getDatabase</a>(connectionName);</div><div class="line"><a name="l00321"></a><span class="lineno">  321</span>&#160;         }</div><div class="line"><a name="l00322"></a><span class="lineno">  322</span>&#160;      }</div><div class="line"><a name="l00323"></a><span class="lineno">  323</span>&#160;</div><div class="line"><a name="l00324"></a><span class="lineno">  324</span>&#160;      <span class="keywordflow">return</span> QSqlDatabase();</div><div class="line"><a name="l00325"></a><span class="lineno">  325</span>&#160;   }</div><div class="line"><a name="l00326"></a><span class="lineno">  326</span>&#160;</div><div class="line"><a name="l00327"></a><span class="lineno">  327</span>&#160;<span class="keyword">private</span>:</div><div class="line"><a name="l00328"></a><span class="lineno">  328</span>&#160;   QMutex mutex;</div><div class="line"><a name="l00329"></a><span class="lineno">  329</span>&#160;</div><div class="line"><a name="l00330"></a><span class="lineno">  330</span>&#160;   QMap&lt;QString, DBSetting&gt; m_settings;</div><div class="line"><a name="l00331"></a><span class="lineno">  331</span>&#160;   QThreadStorage&lt;ThreadDBPool*&gt; m_dbPool;</div><div class="line"><a name="l00332"></a><span class="lineno">  332</span>&#160;</div><div class="line"><a name="l00333"></a><span class="lineno">  333</span>&#160;   QString m_defaultConnName;</div><div class="line"><a name="l00334"></a><span class="lineno">  334</span>&#160;</div><div class="line"><a name="l00335"></a><span class="lineno">  335</span>&#160;<span class="keyword">private</span>:</div><div class="line"><a name="l00336"></a><span class="lineno">  336</span>&#160;   <a class="code" href="class_sql_factory.htm">SqlFactory</a>()</div><div class="line"><a name="l00337"></a><span class="lineno">  337</span>&#160;   {}</div><div class="line"><a name="l00338"></a><span class="lineno">  338</span>&#160;};</div><div class="line"><a name="l00339"></a><span class="lineno">  339</span>&#160;</div><div class="line"><a name="l00340"></a><span class="lineno">  340</span>&#160;</div><div class="line"><a name="l00341"></a><span class="lineno">  341</span>&#160;<span class="preprocessor">#endif // EASYQTSQL_SQLFACTORY_H</span></div><div class="ttc" id="struct_sql_factory_1_1_d_b_setting_htm_a5e5c83e7260175e8f538f072897976f5"><div class="ttname"><a href="struct_sql_factory_1_1_d_b_setting.htm#a5e5c83e7260175e8f538f072897976f5">SqlFactory::DBSetting::msSqlServerODBC</a></div><div class="ttdeci">static DBSetting msSqlServerODBC(const QString &amp;server, const QString &amp;database, const QString &amp;userID, const QString &amp;password, const ConnParameters &amp;extraParams=ConnParameters())</div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:84</div></div>
<div class="ttc" id="class_sql_factory_1_1_thread_d_b_pool_htm"><div class="ttname"><a href="class_sql_factory_1_1_thread_d_b_pool.htm">SqlFactory::ThreadDBPool</a></div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:202</div></div>
<div class="ttc" id="class_sql_factory_htm_aba9fae52920d49b9c11e12f243690bfa"><div class="ttname"><a href="class_sql_factory.htm#aba9fae52920d49b9c11e12f243690bfa">SqlFactory::config</a></div><div class="ttdeci">SqlFactory * config(const DBSetting &amp;settings, const QString &amp;connectionName=QSqlDatabase::defaultConnection)</div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:267</div></div>
<div class="ttc" id="struct_sql_factory_1_1_d_b_setting_htm_a1f4dcce1487c3354ab53e648c02c7f4e"><div class="ttname"><a href="struct_sql_factory_1_1_d_b_setting.htm#a1f4dcce1487c3354ab53e648c02c7f4e">SqlFactory::DBSetting::msSqlServerNativeClient90ODBC</a></div><div class="ttdeci">static DBSetting msSqlServerNativeClient90ODBC(const QString &amp;server, const QString &amp;database, const QString &amp;userID, const QString &amp;password, const ConnParameters &amp;extraParams=ConnParameters())</div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:109</div></div>
<div class="ttc" id="class_sql_factory_1_1_thread_d_b_pool_htm_acaa0328fa9e8fd5975cbe8a6515ebad8"><div class="ttname"><a href="class_sql_factory_1_1_thread_d_b_pool.htm#acaa0328fa9e8fd5975cbe8a6515ebad8">SqlFactory::ThreadDBPool::addConnection</a></div><div class="ttdeci">void addConnection(const DBSetting &amp;settings, const QString &amp;connectionName)</div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:222</div></div>
<div class="ttc" id="struct_sql_factory_1_1_d_b_setting_htm_a770f3653954b15a1a6a940765c8ff44f"><div class="ttname"><a href="struct_sql_factory_1_1_d_b_setting.htm#a770f3653954b15a1a6a940765c8ff44f">SqlFactory::DBSetting::DBSetting</a></div><div class="ttdeci">DBSetting(const QString &amp;type, const QString &amp;connectionString)</div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:58</div></div>
<div class="ttc" id="struct_sql_factory_1_1_d_b_setting_htm_a0f6188ce9c0615f08c3d2421363e6ef8"><div class="ttname"><a href="struct_sql_factory_1_1_d_b_setting.htm#a0f6188ce9c0615f08c3d2421363e6ef8">SqlFactory::DBSetting::msSqlServerODBC</a></div><div class="ttdeci">static DBSetting msSqlServerODBC(const QString &amp;server, const QString &amp;database, const ConnParameters &amp;extraParams=ConnParameters())</div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:97</div></div>
<div class="ttc" id="struct_sql_factory_1_1_d_b_setting_htm_a1e8c5e64de22656dab6a737827d55bb7"><div class="ttname"><a href="struct_sql_factory_1_1_d_b_setting.htm#a1e8c5e64de22656dab6a737827d55bb7">SqlFactory::DBSetting::msSqlServerNativeClient90ODBC</a></div><div class="ttdeci">static DBSetting msSqlServerNativeClient90ODBC(const QString &amp;server, const QString &amp;database, const ConnParameters &amp;extraParams=ConnParameters())</div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:122</div></div>
<div class="ttc" id="class_sql_factory_1_1_thread_d_b_pool_htm_afec68318f044937be7ef65dbb695fb7a"><div class="ttname"><a href="class_sql_factory_1_1_thread_d_b_pool.htm#afec68318f044937be7ef65dbb695fb7a">SqlFactory::ThreadDBPool::~ThreadDBPool</a></div><div class="ttdeci">~ThreadDBPool()</div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:206</div></div>
<div class="ttc" id="struct_sql_factory_1_1_d_b_setting_htm_abbdcd2f1826a79af0ae96a4841f339c6"><div class="ttname"><a href="struct_sql_factory_1_1_d_b_setting.htm#abbdcd2f1826a79af0ae96a4841f339c6">SqlFactory::DBSetting::sqlite</a></div><div class="ttdeci">static DBSetting sqlite(const QString &amp;fileName)</div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:75</div></div>
<div class="ttc" id="class_sql_factory_htm_a99a9a94d77ee0cb3dbfbdce112764923"><div class="ttname"><a href="class_sql_factory.htm#a99a9a94d77ee0cb3dbfbdce112764923">SqlFactory::getInstance</a></div><div class="ttdeci">static SqlFactory * getInstance()</div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:40</div></div>
<div class="ttc" id="struct_sql_factory_1_1_d_b_setting_htm_a4cecaec15efae6fcef128aca09603513"><div class="ttname"><a href="struct_sql_factory_1_1_d_b_setting.htm#a4cecaec15efae6fcef128aca09603513">SqlFactory::DBSetting::DBSetting</a></div><div class="ttdeci">DBSetting()</div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:55</div></div>
<div class="ttc" id="class_sql_factory_1_1_thread_d_b_pool_htm_ae26407e9a40ec0077c71dcad8836cff7"><div class="ttname"><a href="class_sql_factory_1_1_thread_d_b_pool.htm#ae26407e9a40ec0077c71dcad8836cff7">SqlFactory::ThreadDBPool::getDatabase</a></div><div class="ttdeci">QSqlDatabase getDatabase(const QString &amp;connectionName) const</div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:246</div></div>
<div class="ttc" id="class_sql_factory_htm_a18d96e47f512a3bc4ba8cb07336acb54"><div class="ttname"><a href="class_sql_factory.htm#a18d96e47f512a3bc4ba8cb07336acb54">SqlFactory::getDatabase</a></div><div class="ttdeci">QSqlDatabase getDatabase(const QString &amp;connectionName=QSqlDatabase::defaultConnection)</div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:292</div></div>
<div class="ttc" id="struct_sql_factory_1_1_d_b_setting_htm_aca20852536794beb79fa735b219c29cb"><div class="ttname"><a href="struct_sql_factory_1_1_d_b_setting.htm#aca20852536794beb79fa735b219c29cb">SqlFactory::DBSetting::DBSetting</a></div><div class="ttdeci">DBSetting(const QString &amp;type, const ConnParameters &amp;params)</div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:62</div></div>
<div class="ttc" id="class_sql_factory_1_1_thread_d_b_pool_htm_a57d1dfa755fdfdf49c653acd596fabf9"><div class="ttname"><a href="class_sql_factory_1_1_thread_d_b_pool.htm#a57d1dfa755fdfdf49c653acd596fabf9">SqlFactory::ThreadDBPool::connectionExists</a></div><div class="ttdeci">bool connectionExists(const QString &amp;connectionName) const</div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:241</div></div>
<div class="ttc" id="struct_sql_factory_1_1_d_b_setting_htm_a67cc15ea0f8cb7e4d64e1e6a09933f65"><div class="ttname"><a href="struct_sql_factory_1_1_d_b_setting.htm#a67cc15ea0f8cb7e4d64e1e6a09933f65">SqlFactory::DBSetting::sqliteMemory</a></div><div class="ttdeci">static DBSetting sqliteMemory()</div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:70</div></div>
<div class="ttc" id="class_sql_factory_htm_a64dc81e8275c89d1b2b7c7fb383ab475"><div class="ttname"><a href="class_sql_factory.htm#a64dc81e8275c89d1b2b7c7fb383ab475">SqlFactory::clone</a></div><div class="ttdeci">SqlFactory * clone(const QString &amp;newConnectionName, const QString &amp;connectionName)</div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:276</div></div>
<div class="ttc" id="class_sql_factory_htm"><div class="ttname"><a href="class_sql_factory.htm">SqlFactory</a></div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:36</div></div>
<div class="ttc" id="struct_sql_factory_1_1_d_b_setting_htm_a1adc28c8e45cde95aa094c4172b79beb"><div class="ttname"><a href="struct_sql_factory_1_1_d_b_setting.htm#a1adc28c8e45cde95aa094c4172b79beb">SqlFactory::DBSetting::ConnParameters</a></div><div class="ttdeci">QVector&lt; KeywordValuePair &gt; ConnParameters</div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:53</div></div>
<div class="ttc" id="struct_sql_factory_1_1_d_b_setting_htm_a9efb6d2e2221b3e4347171149eb684dd"><div class="ttname"><a href="struct_sql_factory_1_1_d_b_setting.htm#a9efb6d2e2221b3e4347171149eb684dd">SqlFactory::DBSetting::DBSetting</a></div><div class="ttdeci">DBSetting(const QString &amp;type, const QString &amp;host, int port, const QString &amp;username, const QString &amp;password, const QString &amp;dbname)</div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:66</div></div>
<div class="ttc" id="struct_sql_factory_1_1_d_b_setting_htm_a7a079094d80a3ad77a621f08cf0c942b"><div class="ttname"><a href="struct_sql_factory_1_1_d_b_setting.htm#a7a079094d80a3ad77a621f08cf0c942b">SqlFactory::DBSetting::getType</a></div><div class="ttdeci">QString getType() const</div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:135</div></div>
<div class="ttc" id="struct_sql_factory_1_1_d_b_setting_htm_a512b6207e0166201c62da1a764f7425c"><div class="ttname"><a href="struct_sql_factory_1_1_d_b_setting.htm#a512b6207e0166201c62da1a764f7425c">SqlFactory::DBSetting::KeywordValuePair</a></div><div class="ttdeci">QPair&lt; QString, QString &gt; KeywordValuePair</div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:52</div></div>
<div class="ttc" id="struct_sql_factory_1_1_d_b_setting_htm"><div class="ttname"><a href="struct_sql_factory_1_1_d_b_setting.htm">SqlFactory::DBSetting</a></div><div class="ttdef"><b>Definition:</b> EasyQtSql_SqlFactory.h:48</div></div>
</div><!-- fragment --></div><!-- contents -->
</div><!-- doc-content -->
<!-- start footer part -->
<div id="nav-path" class="navpath"><!-- id is needed for treeview function! -->
  <ul>
    <li class="navelem"><a class="el" href="dir_ccd1b38e141953c502dde9cd8646e4d8.htm">EasyQtSql</a></li><li class="navelem"><a class="el" href="_easy_qt_sql___sql_factory_8h.htm">EasyQtSql_SqlFactory.h</a></li>
    <li class="footer">Generated by
    <a href="http://www.doxygen.org/index.html">
    <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.14 </li>
  </ul>
</div>
</body>
</html>
